omc0128 - collateral located in a reporting member state omc0128 real estate collateral location region needs corresponding country

Card of business rule collateral located in a reporting member state omc0128 real estate collateral location region needs corresponding country

Name

collateral located in a reporting member state omc0128 real estate collateral location region needs corresponding country

Code

omc0128

Comment

A region is always part of a country. When the attribute 'real estate collateral location region' is reported next to the attribute 'real estate collateral location country', the reported region must be part of the reported country.

Rule Type

Constraint


Server expression of the business rule collateral located in a reporting member state omc0128 real estate collateral location region needs corresponding country

(if ( 'collateral located in a reporting member state'.'reporting agent identifier' = 'immovable property'.'reporting agent identifier'
and 'collateral located in a reporting member state'.'protection identifier' = 'immovable property'.'protection identifier'
and 'collateral located in a reporting member state'.'reporting reference date' = 'immovable property'.'reporting reference date'
and 'collateral located in a reporting member state'.'real estate collateral location region' is not null)
then
(( 'collateral located in a reporting member state'.'real estate collateral location region' = 'NUTS 3 region'.'NUTS 3 code'
and 'immovable property'.'real estate collateral location country' = 'NUTS 3 region'.'country')
or 'collateral located in a reporting member state'.'real estate collateral location region' = "Unknown"))


List of DNB-specific attributes of the business rule collateral located in a reporting member state omc0128 real estate collateral location region needs corresponding country

Name

Value

business rule classification

other model constraint

business rule scope

Checked within the data delivery

business rule status

active business rule

number of dependencies

1

severity

signalling


List of attached objects of the business rule collateral located in a reporting member state omc0128 real estate collateral location region needs corresponding country

Short Description

Entity Attribute 'collateral located in a reporting member state.real estate collateral location region'